Excel Example

Histogram

Step 1: Enter your frequency table into Excel by writing a column for your classes and a column for your frequencies.

histogram excel example step 1

Step 2: Click "insert" in the top menu options then select the desired cells by clicking the mouse and dragging

Excel Histogram example step 2

Step 3: Select the option "column" from top menu

Excel Histogram example step 3

Step 4: From dropdown menu select bar graph.

Excel Histogram example step 4

Step 5: Right click graph and choose "format" to change appearance options

Excel Histogram example step 5

To see this done watch the following video: